SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200152 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200152 [ RunTime:0.002979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402988,687371,111000,93689,418521,509652,550805,747032,190730,411498,71908,342176,216900,712101,683331,176712,538870,228669,1014641,388675,578175,736360,670909,338611,698836,118058,643234,599668,327081,665764,77552,44964,358878,70255,892857,376796,755361,136052,803261,792578,441446,29046,817730,359549,1042708,303723,571173,535195,756079,929865,857534,404064,1046894,541520,711341,1000469,138594,109271,599703,277341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]