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` = 410963 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410963 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41342,171538,270552,781436,346538,850852,818409,173088,260848,635117,70684,276360,436030,979147,741796,346403,548591,23081,569145,976736,320502,942502,167693,719210,83981,16159,593437,101299,8838,427641,641631,823801,346663,255099,533628,189514,901692,824129,149571,791824,270228,896,390873,1017414,14594,392099,380306,754300,1026765,47544,567101,43512,160606,926346,789710,521401,709936,636654,122672,78084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]