SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404540 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404540 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601763,592444,378386,387540,458906,887237,125724,1004697,659865,659110,152297,851282,85673,215205,889308,847513,970740,825451,479876,838742,650781,906378,655577,189000,873623,994042,278476,219010,51365,632755,195114,954308,512084,573970,268435,87345,314053,530623,93442,536535,87067,339141,572218,624049,364077,301710,617490,644758,554777,974679,574785,90669,55058,826338,17863,688773,483546,270544,771388,32919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]