SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50438 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50438 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297044,440676,754633,985952,874281,360491,445759,834555,209232,867712,17219,475755,557156,165589,143612,296520,9958,186389,94356,943497,272777,326137,839573,662809,389163,732232,428833,795074,35010,340645,300549,78752,111697,79724,266069,450104,303260,476684,260990,64556,787780,327780,579615,30143,939074,974946,417513,477132,620037,686787,777651,918999,718783,630661,334441,172763,4406,995842,475723,681196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]