SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51582 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51582 [ RunTime:0.003113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570884,168770,216229,251667,797983,646727,595798,606454,940851,11593,11336,374907,805495,776371,975505,818945,663261,234535,1021049,476767,705438,402881,17667,449953,91201,72489,474369,160736,911267,1006285,325624,710609,500354,761589,163387,776910,725484,392069,758812,716021,954145,963276,261422,576857,414706,354264,999817,286220,536480,338889,992270,841419,154360,365216,872027,982849,536541,420663,853571,755649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]