SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440437 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440437 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485629,397008,919225,291585,941045,321689,684912,928630,291973,359138,531202,381378,525113,1033249,418159,553885,42379,150703,943688,717065,513631,836806,289410,391711,779068,590544,32627,994860,784636,479749,143971,310384,987764,610153,1044920,142291,612049,460555,1003347,1039628,974009,503640,28119,910309,970885,213574,950278,952161,1026850,547007,927354,106731,319420,113628,994408,445993,181510,101367,4808,779344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]