SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000907s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601017 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601017 [ RunTime:0.002999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519024,920415,664501,757383,261685,202456,435571,152859,746062,91747,384009,302971,1045354,670202,927506,106893,883125,538003,258534,909998,264086,995457,696715,894923,806667,314707,480350,467273,273365,730214,260239,980541,328705,787536,1043859,35997,751871,450353,534727,877420,305278,168106,40601,548748,416880,321082,52926,627403,772862,386514,375709,216420,173979,895476,877807,570953,546256,926248,731031,215581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]