SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 187415 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 187415 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840460,818117,41713,489645,280170,223245,836239,49138,440663,381322,921076,967947,424881,24030,310362,1011318,1010218,128848,107460,612221,232810,662394,732314,301124,490994,561175,856080,1005769,207007,730622,986323,272241,297805,594105,543907,1028641,936523,858369,389210,465528,646312,740395,131642,604878,1006531,961877,676690,1030054,266252,342692,910140,875969,532322,536726,924240,770017,888314,264426,759025,1012900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 187415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 187415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]