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` = 432413 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432413 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116306,264341,629474,651357,985270,604047,978422,771802,1013762,606755,981899,178002,842340,60157,817170,415899,650979,466292,879828,200263,440769,332938,721523,332086,712003,494790,1014151,990974,143914,158734,926080,184282,660433,604526,593976,770162,186934,375318,1030171,677561,397226,505493,988403,615298,413995,1016128,422880,621155,920456,528780,484776,338666,916084,615625,360549,367393,931216,337963,482209,29856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]