SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022972 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022972 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217027,1021796,705352,340143,618196,293039,663851,505276,365838,421570,331162,944463,960601,856088,677748,1032094,372068,922101,304383,542109,22084,32650,312175,449973,810999,879486,603096,731364,374093,1040974,480978,487584,939243,681286,807259,698799,227846,438335,839391,10657,632626,1038265,133863,342531,874642,163017,130086,438209,147162,207839,347411,119150,1018556,551576,603961,595976,52465,199986,783135,290031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]