SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002527s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424035 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424035 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640093,440323,879872,47809,368653,676526,479421,781460,283655,208197,86368,2134,615630,131729,29272,355414,921548,392969,327383,41224,1010845,76402,1012534,149043,650895,749987,581331,829101,805700,1027526,329849,190884,459221,374748,645932,695943,662378,130991,342119,270077,677908,688141,268632,509994,408577,848660,579468,491450,1017753,24161,528323,633410,202645,29607,388903,232512,595171,685599,953589,1035177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]