SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403621 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403621 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643347,638061,777100,703684,35244,333453,636669,723344,546863,316222,371883,415489,134804,989587,751721,45247,191288,408652,1007618,232668,412652,227903,55356,608637,676918,503334,274298,1025420,1025383,748149,561424,227493,168083,999727,418480,284175,122778,619375,56029,541283,309895,760285,210117,642901,792281,137153,266415,725213,316512,693240,833599,97054,272874,942102,675538,415992,517717,904345,548582,539526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001916s ]