SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51099 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51099 [ RunTime:0.004142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273704,1023574,247526,220404,571471,359239,788351,970737,883244,600283,739842,1025880,563519,182870,105944,294426,149525,899342,102033,265395,34110,888392,773809,295887,90033,840037,315207,570809,237630,489601,1027067,439858,181259,762410,244977,332155,721882,112714,846772,179003,501766,607484,1013824,803830,820752,937518,644640,938507,324115,453402,1026975,1011669,470529,119133,228739,540628,483595,1011357,685601,549809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000914s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]