SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018078 LIMIT 1 [ RunTime:0.001791s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018078 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844327,577535,963869,725195,60557,781039,298104,912464,567395,72291,796376,604109,900536,197034,6591,654699,275453,940735,831042,897763,420529,721760,986783,996375,645451,547186,38133,703938,200875,994096,134431,449737,192986,153349,82309,386569,925005,164401,734577,903750,752733,203131,941978,265113,864355,400786,700135,510513,36943,1027246,293705,250510,155985,498562,4016,321736,354990,318658,593437,1040901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002387s ]