SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411672 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411672 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955948,377602,381890,271247,141998,301013,572597,671701,70889,1003499,829030,20986,522406,528690,883041,503420,791669,892102,994615,549468,862403,1000437,895988,1016018,255656,644131,574044,1035173,957305,971334,238627,252431,479098,203212,320830,666749,13230,852920,1024602,100046,510908,279445,12720,185322,35335,51050,455822,456992,968308,42932,573500,997262,771931,664107,471349,333830,10655,884884,794643,985557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411672 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411672 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]