SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34842 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34842 [ RunTime:0.003425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763078,407274,319390,415308,379854,666021,288070,707415,446554,801215,751610,811575,357696,192296,351065,318733,992178,749986,598632,649090,667907,880971,932750,352373,332768,293035,784574,874886,57835,646459,942673,206012,479565,846104,25878,11136,200002,802842,81144,773729,883720,107651,129718,1045437,84337,748733,567994,942689,121352,457538,1024804,539714,110460,830934,626590,66445,295943,976505,276865,800901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000968s ]