SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022051 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022051 [ RunTime:0.002938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230378,11662,916327,532967,145932,196233,235319,4308,20211,962973,596551,746104,916042,475058,589221,310342,152746,894763,549346,283099,704203,402504,779477,174254,41490,852509,185499,78069,970897,885788,305578,769457,98945,953838,378647,450714,836943,859861,523726,288437,336427,123621,487731,486856,623397,715846,269102,959129,962133,367702,554144,647826,680411,279669,522580,615114,598709,259111,912796,876062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]