SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402318 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402318 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261623,931736,746910,195780,190391,944365,131336,898904,841495,994126,944421,981747,602607,414513,293353,346974,373695,787472,240856,586038,78817,846872,315810,147737,299111,735151,707887,195828,612445,348049,78438,535805,575683,784382,415166,568052,264835,205115,55265,885406,155401,394214,842851,185168,682368,669398,271237,611176,463405,913499,547584,448798,873218,441790,3480,331652,875967,3482,839506,119583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]