SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566091 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566091 [ RunTime:0.001284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185612,685732,512474,805954,688190,1027404,16905,931503,575876,280751,36177,237965,460540,827358,540657,913871,990984,198396,759221,543405,362514,115382,254365,96671,1008355,964948,783084,750210,901447,988125,561997,673982,307886,178544,411866,801043,615769,603582,90820,203011,736835,503355,520138,1018008,485400,743069,512944,701799,395704,970379,106573,902371,174068,968084,310199,523675,726440,217577,585072,336515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]