SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411181 LIMIT 1 [ RunTime:0.005411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411181 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932145,269084,520268,395494,940298,488705,324380,932719,1025175,553869,148854,22681,180478,480291,504023,788149,176801,757481,816132,349657,252983,819859,36006,709334,426928,359469,745990,419274,5802,837015,181043,8933,272165,850831,748914,304867,1048884,779337,44802,604469,747033,592045,872532,607972,329238,409443,957335,200071,211634,827986,270641,355835,1044492,981006,453850,755074,456131,539931,25068,631748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]