SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44193 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44193 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510652,137588,526956,563285,840221,99334,417140,1024614,230799,138638,299223,678630,886730,841358,222883,180420,481491,626913,771994,513844,144149,90595,492559,285869,826043,368609,153681,313237,496478,411334,838116,85041,1019101,676749,329660,460231,727850,681314,153735,559868,89165,622698,57022,122763,900246,636869,309828,403186,964005,529717,1001022,517294,867382,229687,849255,2265,266045,472177,953387,835808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]