SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521604 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521604 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389751,729345,143502,634447,628051,747659,559370,463467,355874,676230,880746,805746,142010,397409,865434,774333,970744,380899,205406,269031,641731,39267,932150,251710,426154,951448,49534,555787,400795,193183,678761,334448,465685,464667,161771,890429,70257,426711,516487,727636,162067,961564,683824,119594,494320,748991,448742,819397,1021585,536680,956641,843724,73113,584215,364747,818496,910706,309244,931603,132926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]