SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406240 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406240 [ RunTime:0.003095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184894,692677,330079,1011346,304390,100361,461903,722223,531997,51668,303869,116595,595162,489360,985990,226927,893401,430883,811741,745620,49819,561647,194067,224011,736817,755176,697552,635442,132778,59812,938300,611121,882221,913502,274533,399104,660378,586188,399223,444706,360193,378620,68643,506955,160925,1007174,661082,650219,932728,529692,499301,46897,562541,734079,477917,861100,574543,481979,162341,1003924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]