SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453850 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453850 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517204,408678,960444,40234,722819,637073,897614,471553,655831,629633,122604,921756,162954,664359,745553,236082,598287,344902,1036707,488120,645344,400106,989481,690555,554436,327868,898867,36021,229404,127622,462010,864022,43857,959581,776945,366352,315174,583304,683391,232278,823443,298238,504713,683293,564956,428243,145112,842119,280076,965405,607167,118451,443282,243574,647507,862762,470911,639765,398047,591398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]