SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408552 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408552 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693177,821781,193168,468059,622885,200543,46147,369005,381615,987440,100217,101048,432239,455411,794535,543987,644824,178200,823577,256839,761862,1005129,1027449,375144,1011694,697124,222339,260342,1047304,783777,537508,225898,161304,125877,900212,247,327697,749613,695461,300498,483370,1008815,315998,449289,436172,650428,359436,1020524,889626,652471,157469,689178,777487,382035,14700,518261,31447,718067,88877,367138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]