SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433311 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433311 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187776,276098,529063,421989,669872,750177,927069,817510,986230,34958,470181,113125,482045,449021,458613,586842,74401,209692,433916,94083,156758,827995,820236,553234,208895,369400,828655,882712,224797,224972,762911,991192,532366,366723,626844,512491,98306,300867,865292,407685,525951,465027,281650,439483,32536,205533,758360,1032325,60169,253331,299161,849846,661207,524071,724480,399462,942399,1025016,999235,596494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]