SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512570 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512570 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569,685243,1021221,924205,218809,1022346,757646,689132,287330,525919,743856,875638,163670,215528,187271,934706,884439,696287,348079,152778,488891,83053,944613,19526,910236,176039,343125,254525,929288,1010895,441313,629989,615627,849074,723568,951027,874050,376176,609825,395078,356979,384276,819548,915570,741814,301686,717643,170498,240998,550402,415080,87480,66759,823008,741137,205323,944554,295015,584928,759109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]