SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 152781 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 152781 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830444,245011,1036168,728962,587730,740392,131688,884110,342403,380821,746722,508992,478162,327569,459538,1029020,970105,220942,112761,434178,652050,845728,649089,938580,179341,691238,171216,996694,387825,541085,285489,248188,682896,803883,406566,205138,633720,907038,588301,531813,720032,630365,29222,598031,486599,18965,722517,378013,992134,852329,290734,965863,365101,406449,513680,516606,746124,274484,496423,902644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 152781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 152781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]