SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199711 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199711 [ RunTime:0.004466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197928,668121,175490,177871,862623,808087,214717,434955,486766,615553,803649,422237,143016,1003737,535066,124429,497669,196738,148584,427009,107038,767239,614973,591557,262310,1021424,214694,76932,994169,435982,413372,894832,75463,446150,896169,334284,114780,261129,967437,127145,442362,948895,476454,721558,227463,250707,597390,962250,112729,399347,255567,666463,652400,839563,438378,83076,798967,397776,544827,945576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001156s ]