SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020259 LIMIT 1 [ RunTime:0.000670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020259 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803001,957319,156453,970602,196081,873160,521512,117858,346061,87142,441855,810315,691965,373580,782670,533936,424993,940732,1025080,59790,368386,231798,242751,218869,465078,329945,143603,926577,54889,1012214,895419,178999,368878,509336,125205,420687,547564,781866,469432,756015,807210,1031246,849436,937724,738061,649926,474090,976624,66173,925111,616037,555873,934343,162864,926699,772593,365187,240750,433262,542907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]