SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200339 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200339 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444999,423776,438323,912239,370050,138966,955042,948694,5507,967111,472842,661015,298492,76496,928096,745099,75090,393104,35485,310782,567360,488619,687091,624563,36417,761805,755431,1033103,925507,249101,203590,835987,783565,2522,388516,773225,2842,1027057,371835,319767,426745,141216,392169,195293,127976,637601,639013,908222,571459,696823,742780,177004,791842,1001251,616062,759066,520191,199850,593200,295462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200339 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200339 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001050s ]