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` = 410030 LIMIT 1 [ RunTime:0.003196s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410030 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569074,901168,375898,287012,503044,81022,427020,1005929,964746,105192,226659,657574,363172,193158,211022,155714,373390,604356,954600,464543,892196,275631,169732,453931,849068,19677,947886,971415,925011,711690,129551,390143,636745,859532,310758,700396,522627,575061,546086,336812,1019326,744478,907811,1040183,224859,916428,989574,426110,427759,310178,259795,35665,832335,301415,755668,685562,873738,817711,366744,683898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]