SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454381 LIMIT 1 [ RunTime:0.000976s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454381 [ RunTime:0.002804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531528,210049,173013,114995,1022428,523005,671166,18841,524051,119465,751460,740006,468683,1022355,280080,966083,1034659,642045,613877,777159,268473,904252,466005,7468,874266,798639,671865,162633,154758,991237,715863,34865,259277,320321,543201,89085,420358,455375,866485,602388,494531,406660,617295,77219,48429,384164,104002,693938,476455,534625,387945,168606,593549,69195,977719,71221,562029,547007,813652,110470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000870s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]