SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001722s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341912 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341912 [ RunTime:0.003111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335998,164704,536836,999803,1000758,425589,447006,27225,77479,919486,483170,985354,164587,826119,280190,743292,432541,716985,706100,656201,42166,156009,6313,845322,584348,362296,545774,951955,702193,214236,605648,666584,654321,229238,965289,538320,11895,867739,828165,1046704,931631,236328,591594,514440,650466,404922,931167,64125,92912,685859,441450,1031696,451478,325461,936618,88401,982669,894745,596608,56873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]