SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401460 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401460 [ RunTime:0.002890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95552,749519,275085,640807,872399,313598,400941,545422,983910,802592,325260,711249,68537,808149,321532,142214,357501,854579,833764,646846,189418,194105,297471,695430,50312,459235,913914,555361,1005607,898141,435922,938471,211426,568563,420359,868571,780773,208713,419805,1018330,426252,866669,793840,39386,377612,185085,637829,413860,563700,34203,562766,689400,993733,677110,534135,206969,1027629,1043358,303728,273651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]