SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53500 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53500 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683236,44725,247859,96877,197164,1044582,982528,1004884,541730,529513,280470,273936,941127,821035,568805,165488,157677,806116,302904,185505,55016,509642,613881,356382,32585,712951,522469,214205,87761,730088,847350,128322,35175,474065,914243,131668,126241,431709,673975,374095,982215,10496,856862,154645,167164,511191,506141,218228,819635,180780,196617,369664,878137,140968,1010534,872906,380160,260865,875756,148593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]