SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413511 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413511 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55991,726239,133765,386456,791860,484548,751605,26558,462254,862372,344452,978024,658141,876408,811698,483480,908620,666230,698645,1035550,30480,317420,510010,925310,1041026,718633,384494,144133,178311,860678,535523,59362,808344,934783,929781,362775,300543,761174,1009262,170785,528372,473558,488268,422701,1042224,705667,910184,695564,930437,101270,724226,821541,787956,321136,497371,398222,83305,660916,687428,576236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]