SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504571 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504571 [ RunTime:0.003003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144233,125752,156606,486662,689031,614549,146902,993884,601671,618187,680059,364900,727003,643254,779584,332458,965556,401193,261405,1045061,722981,883101,796925,583279,873061,185866,994821,136303,768651,561906,147530,6959,977495,651254,165694,589699,143438,105854,967297,1003400,730463,176872,414829,141675,120305,65459,949255,730254,792185,785390,858134,1025909,867560,227235,303642,991968,498808,29971,717022,488197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002930s ]