SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198105 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198105 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121421,717292,841083,872833,988155,658559,579274,157689,201873,10953,242684,761371,414224,310894,903325,209308,446919,450770,120293,943672,472927,591163,285769,105276,450373,900338,661226,7530,722465,618922,46468,467662,135422,179760,1016007,5635,812569,748736,403842,861351,76459,210549,85631,705233,127461,958647,64403,329080,313093,314219,43229,583186,363389,661002,224131,868244,762212,622865,120372,1009790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001423s ]