SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003803s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478580 LIMIT 1 [ RunTime:0.002220s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478580 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422431,693435,9888,533962,559300,571428,897224,464667,452605,420598,649948,521074,798548,741563,633107,619669,612451,859095,448704,916366,717153,855768,470753,325121,317991,30167,782752,980635,681722,203637,636062,821025,323760,156207,129632,540480,193673,662289,838011,576761,77953,987622,205235,949074,300397,56342,594488,185732,915853,1025766,500375,416641,987134,318742,681988,640917,815706,236916,1029314,816629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]