SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31003 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31003 [ RunTime:0.004444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969210,979670,268843,741048,82713,849032,224229,162627,248956,528115,53783,882383,461830,250812,869744,463603,820039,166880,785141,779948,241689,477891,218332,625667,477185,653744,831150,594741,37114,807703,1048473,517594,722395,496639,522437,748745,476442,751821,851965,476897,272180,888707,1040168,886929,478290,922780,297209,345733,976332,468881,560324,908042,1021878,842121,637561,340946,963499,910926,660264,243657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]