SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26102 LIMIT 1 [ RunTime:0.000614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26102 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843783,891912,326863,150065,115344,795520,469103,226578,283651,577412,236325,496172,131052,1027608,401558,37152,1023022,321859,40101,9812,986103,293283,42657,592129,253852,93834,97495,702301,890271,880189,389982,155501,575021,945755,162088,940513,966658,102509,192203,370472,506698,931237,793584,720882,64243,673377,681259,379097,903169,666773,894577,397226,1018656,909098,487257,260068,179869,438977,12603,178046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]