SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409818 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409818 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952660,208391,436225,283751,240927,784236,278231,405450,77108,481323,758964,994172,587057,418254,806250,445164,616424,617071,204522,251388,542604,99251,992987,961559,260398,345755,950690,24884,290379,134645,309004,559810,681827,470507,203353,734275,372437,698522,73318,111156,879227,544457,79521,282036,286882,386393,854418,966871,1023417,78787,609434,693154,345738,1045108,352384,129418,651979,567113,827401,350317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]