SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200470 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200470 [ RunTime:0.002287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646987,804104,96497,901241,429109,145839,252112,207414,164131,556032,956074,165448,465354,110108,622353,864683,621826,476476,441463,733464,748,490914,1005032,829565,729387,855868,1023101,787585,295569,273071,641745,846782,299565,1048010,600762,909927,1003726,982514,163707,219098,950496,680847,246336,636299,655510,72570,452594,933283,861223,318735,321659,343321,689084,807828,372460,802812,174669,392511,1009117,17037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]