SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545888 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545888 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872686,139143,986261,315145,520972,60267,651314,506130,85802,908053,654012,4039,854955,60335,601460,726382,60461,627250,612898,366615,87499,891694,1006443,54309,500152,290333,557351,356677,375570,478515,543311,532561,511445,352261,722976,630414,41580,628790,162390,335671,1017945,90474,148236,21091,412179,55330,832428,761403,407455,809776,146406,450194,654868,485146,7542,782289,694694,441399,805825,112631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]