SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423106 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423106 [ RunTime:0.002332s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923799,20031,260124,873311,922033,641109,574804,60406,414491,793538,219873,16982,154562,923648,936914,300793,653750,11631,580053,285328,683145,824606,553733,773233,77984,869506,920245,229722,360518,169991,800064,403533,542616,638084,240670,422663,591789,638947,545896,545456,768753,748857,774640,369870,753537,764661,545566,392130,682345,94985,816362,1036126,406794,929139,247131,617036,975833,398077,447572,784538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]