SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505192 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505192 [ RunTime:0.002404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118873,586513,612785,412638,427721,74726,46950,49485,233547,917214,858829,898586,731722,866643,214793,671541,361131,682823,553870,744665,483876,269679,721514,535015,5882,218734,932002,66165,838322,26902,194285,62346,71735,182859,936175,985870,538095,863186,623925,127245,538564,88685,1030648,533238,755776,917414,898650,124908,987014,684267,649589,737024,1007054,722946,769417,174850,30324,316409,517438,111521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]