SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029588 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029588 [ RunTime:0.001344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993839,910365,365489,3562,363008,755460,710163,388563,405099,744685,979910,630217,426827,334273,985050,1023569,880052,491110,132530,579531,858746,848077,586783,151716,918542,105629,21709,554173,196252,952566,87750,649661,862535,464284,872637,679679,80432,611648,935871,880599,725095,62973,406535,606368,161734,836268,535149,9101,1016334,277544,367260,695985,174574,779509,454443,560635,783925,223611,776077,67108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]