SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974568 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974568 [ RunTime:0.004264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41602,755072,155125,804498,588951,238999,783775,480723,528792,66355,749378,425281,898614,848533,41391,3338,830207,1002184,854226,40748,722610,255092,34903,918307,385923,317814,53832,405108,201489,635217,734462,243182,123859,235299,1041340,106742,331441,524123,52056,606418,228475,816651,44429,520878,321832,285301,929228,161293,357019,271941,866902,64840,199530,644101,528374,367225,656558,557963,443364,906887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]