SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201515 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201515 [ RunTime:0.004665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785267,785203,1017563,419938,429457,1032731,971897,730946,547710,417636,290979,506901,336037,218499,208055,95632,387752,982140,388086,330018,899474,105820,967083,360195,911444,195733,798952,500305,542155,719139,335136,44709,551091,424208,336363,109252,738573,494805,612749,867307,282636,67099,410313,158380,1017550,156420,184123,320725,502598,159621,687600,83308,109254,1042036,59786,603142,124700,73454,538596,925496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]