SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343414 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343414 [ RunTime:0.003011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54801,145891,800655,204401,245989,481965,591660,781229,359758,789737,921888,769631,215140,495157,199880,984891,438027,201205,448324,132403,7606,279423,855107,390897,98782,1022809,286209,368846,229898,411856,918270,822157,349784,524099,744422,1253,963089,368598,344223,158563,2395,541714,402700,892763,100245,428277,590051,670106,1040341,671343,154860,472908,316467,450166,365896,264805,206892,830901,347979,281145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001263s ]