SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001886s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 915045 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 915045 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533211,602275,605990,431358,50506,550884,281642,302185,204842,489538,918180,395955,129030,221438,268311,833741,34236,695629,42678,741449,767972,18716,762107,271509,303931,120059,191788,694413,285140,279571,426622,164351,979193,752496,684898,528704,30590,634659,145095,202883,561098,636227,853825,177779,207177,431160,407157,716545,672079,1009247,246061,306864,774763,956041,521265,475500,423594,880818,1034339,811635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 915045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 915045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]