SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282409 LIMIT 1 [ RunTime:0.002275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282409 [ RunTime:0.009719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27480,263876,821338,426820,296210,958171,739841,297843,604142,99148,338558,985960,794084,546237,375498,868523,336211,574503,799581,738946,101458,373244,428330,152996,782097,660736,537534,550994,446168,639418,788058,503914,1007597,79691,947949,142846,428740,415331,52339,33047,12842,874535,740535,418241,184904,828765,26241,770146,855984,849827,722643,1005196,402426,872452,701099,545097,1020722,367331,635385,443560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]