SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548584 LIMIT 1 [ RunTime:0.000707s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548584 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796339,319285,21078,1029828,207001,939592,320215,437535,474320,992497,314583,282038,446894,88673,378414,913617,437986,238552,269380,29556,394995,699364,488122,469414,593568,506734,474313,904809,871956,390017,89092,994480,814707,786991,240259,817532,15240,180188,331002,684247,383869,565052,457787,291433,413146,524513,349561,998201,27509,982560,997294,971019,715301,1003414,83294,737087,4069,956551,827821,813496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]