SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803543 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803543 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104067,217589,506281,1025791,119288,648185,62601,124808,3779,995253,248106,307590,114147,772753,134876,753370,695275,907147,1015809,1030862,756318,986245,574620,264002,645633,754919,79408,84611,971865,198419,314000,708092,17830,221333,964294,141302,95386,165055,225045,281677,547955,681972,526238,618790,196630,142516,704393,203908,594903,522271,940214,31177,468298,972162,316243,645515,439816,148368,50343,725380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]