SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481245 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481245 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120773,738747,475432,544637,254942,877061,324915,1033685,848468,511210,144641,643443,530723,570146,573433,882817,875537,40711,766108,801000,25181,761657,818095,996201,5911,919921,305470,887715,240363,585239,413407,730535,582144,148333,656352,952328,707364,1034074,696090,319341,150401,546549,783151,476880,785616,386444,126982,835177,455771,772156,679002,202618,532881,1040496,460541,114690,322858,255519,836094,328877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]