SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404495 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404495 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893260,828931,201032,971456,174699,340076,96392,45866,160348,921802,375640,696682,368930,784044,192252,674795,149199,237104,149001,598531,816149,797871,107670,892037,1046644,993600,1037113,405485,189578,221592,582491,746076,685853,888858,584542,826559,267082,941349,373699,670078,1033728,286871,452857,526194,91402,6665,730169,1015620,357687,923572,357690,673698,963919,147480,704694,68112,717649,1015553,707128,294636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002212s ]