SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417614 LIMIT 1 [ RunTime:0.000573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417614 [ RunTime:0.003954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24413,448037,1023679,879956,195134,684655,507284,989192,100403,149272,487139,898472,656854,750661,36662,450573,864889,531195,983123,31411,399366,726941,674619,177588,182087,519380,988726,433644,849265,501803,872300,465993,862600,656572,464821,954616,287898,857958,675406,163756,802741,754974,991540,460403,441070,25194,523594,365174,179115,639150,727306,288188,1046948,717556,7270,836917,655258,250621,492816,322433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001440s ]