SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539457 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539457 [ RunTime:0.002611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826389,437853,597096,645281,355464,462706,815465,204567,646792,405473,901082,87344,304260,936925,834885,847427,891915,801419,888619,778888,46839,505798,498083,248501,671253,337440,633105,245655,153043,872068,887607,4203,500624,93782,626132,867837,119105,462496,1018489,770891,279294,778146,524136,532224,69719,162802,169793,668623,255687,584781,590734,95685,114256,181710,824840,528172,714886,856760,381400,834604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]