SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001710s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019555 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019555 [ RunTime:0.003554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541830,837532,133680,524512,794214,275711,602875,663784,623184,333357,506528,406327,818980,578622,119967,262185,124455,698697,92258,422817,405877,74951,778658,1040017,1019368,594373,89918,126392,226682,724237,986324,1034956,793342,389366,855276,384280,927765,875668,340536,118263,126548,387358,143538,285821,243675,221376,87451,558181,121039,291443,685356,399559,129890,139758,935779,801348,710741,342442,249339,1022405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001659s ]