SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425173 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425173 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671381,857321,450516,523039,207690,268433,1020753,450528,453109,313985,388149,5063,294377,728207,410069,697224,106011,54046,593542,944653,955320,416883,276382,139890,941956,508698,99402,837441,884734,630397,969604,304420,385962,224425,1028067,902916,233283,781760,632970,266511,944175,90925,557945,602348,28228,343160,775541,738124,254150,578564,54881,754621,974165,710118,887412,1021108,754984,369490,606845,587459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]