SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512984 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512984 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799613,845618,169717,979839,324293,549232,39451,934984,638061,546881,25962,257186,967509,650581,372523,900770,137991,701738,453140,752521,767843,967946,997631,516552,452177,251369,614376,701814,961208,1005676,481112,629077,835382,41997,160431,190689,60143,291425,113955,400704,682408,606505,276050,134177,869758,743133,1021270,747579,994037,813277,180335,268394,343770,305931,417095,263769,413613,425736,703059,254868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]