SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98281 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98281 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000919,268763,38514,639873,673277,431718,601401,1039046,937397,827864,864448,150246,543267,598439,776294,575538,503347,747023,917542,706428,579865,1010509,469488,757040,934357,294570,748447,376208,119484,543289,955287,1036659,727714,764266,852824,394626,887416,837160,113251,932247,238264,358898,233210,316114,777091,837518,135406,804158,624368,694556,812763,934723,513056,863926,265196,615923,385507,393574,87584,74391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]