SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311626 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311626 [ RunTime:0.002485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339509,521536,499554,113291,611814,764887,8474,51802,528841,176627,912193,577673,122358,417361,198770,17110,657327,872792,370460,471808,536645,871991,53188,81402,52115,763371,726504,785069,92307,532398,172121,741621,732068,861166,593007,863363,768154,981154,716208,883566,533981,760532,1048230,56243,324701,89636,806883,197899,10409,479796,215331,91727,805517,109441,529500,681802,990309,622529,520691,453407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002656s ]