SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435654 LIMIT 1 [ RunTime:0.000626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435654 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388507,594624,501459,592048,59761,781582,612979,1036610,41544,730564,627159,117288,501654,676493,789941,229823,941534,62982,751885,903983,398508,16976,141215,181779,919586,357475,525970,1014011,549712,7301,99820,114207,405345,720660,779966,897465,115666,765858,718060,255652,16944,650005,542645,768969,1012800,354657,662534,194567,193341,631178,540749,37646,508377,184087,876753,957876,165156,468055,812359,169829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]