SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002008s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178998 LIMIT 1 [ RunTime:0.000738s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178998 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144176,93124,845500,86924,142155,801908,1000601,1045133,571329,553351,109363,443483,239636,23130,506452,1039140,694568,348825,184383,613152,860005,178814,468884,446071,767394,179115,99197,574478,760752,351096,257813,81685,211773,531983,868905,860903,977372,706443,783046,364424,235008,685108,350629,53105,98485,517610,9671,305551,151160,72898,910720,359567,647863,505711,790074,941052,868850,308606,262085,1033600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001190s ]